CREATE EXTERNAL TABLE jms_dwd.dwd_tab_aviation_send_record_base_dt(
  `booking_space_no` bigint COMMENT '订舱号',
  `send_scan_time` timestamp COMMENT '航空发件扫描时间',
  `collect_time` timestamp COMMENT '揽收时间',
  `pick_network_name` string COMMENT '订单所属网点',
  `pick_network_code` string COMMENT '订单所属网点code',
  `pick_network_id` bigint COMMENT '订单所属网点id',
  `pick_agent_area_name` string COMMENT '订单所属代理区',
  `waybill_no` string COMMENT '运单号',
   package_inside_charge_weight decimal(10,2) comment '内部计费重量',
   arrive_scan_time timestamp comment '航空到件扫描时间'
  )
COMMENT '航空发件扫描表'
PARTITIONED BY (
  `dt` string COMMENT '时间分区')
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/dw/hive/jms_dwd.db/external/dwd_tab_aviation_send_record_base_dt';